﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;

public partial class ybqy_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Page.Header.Title = "表1-9  上年固体废物产生及去向情况（单位：吨）";

        SqlConnection sqlcon = new SqlConnection();
        sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString;
        sqlcon.Open();

        SqlCommand sqlcmd = new SqlCommand("select * from a01109 where ShenBaoNianDu='" + Session["ShenBaoNianDu"] + "' and qiyeid=" + Session["qiyeid"], sqlcon);

        SqlDataReader reader = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
        if (!IsPostBack)
        {
            int yy = 0;
            while (reader.Read())
            {
                yy = 1;
                if (reader["code"].ToString() == "Z90")
                {
                    PRODU_CNT1.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT1.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE1.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT1.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT1.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE1.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE1.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER1.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT1.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT1.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT1.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT1.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT1.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT1.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID1.Checked = true;
                    }
                }

                //展现含铬废物
                if (reader["code"].ToString() == "Z21")
                {
                    PRODU_CNT2.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT2.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE2.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT2.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT2.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE2.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE2.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER2.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT2.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT2.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT2.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT2.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT2.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT2.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID2.Checked = true;
                    }
                }

                //展现含铜废物
                if (reader["code"].ToString() == "Z22")
                {
                    PRODU_CNT3.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT3.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE3.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT3.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT3.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE3.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE3.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER3.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT3.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT3.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT3.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT3.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT3.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT3.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID3.Checked = true;
                    }
                }
                //展现含铅废物
                if (reader["code"].ToString() == "Z31")
                {
                    PRODU_CNT4.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT4.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE4.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT4.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT4.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE4.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE4.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER4.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT4.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT4.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT4.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT4.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT4.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT4.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID4.Checked = true;
                    }
                }

                //展现废有机溶剂
                if (reader["code"].ToString() == "Z42")
                {
                    PRODU_CNT5.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT5.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE5.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT5.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT5.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE5.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE5.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER5.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT5.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT5.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT5.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT5.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT5.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT5.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID5.Checked = true;
                    }
                }

                //展现废矿物质
                if (reader["code"].ToString() == "Z08")
                {
                    PRODU_CNT6.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT6.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE6.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT6.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT6.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE6.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE6.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER6.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT6.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT6.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT6.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT6.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT6.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT6.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID6.Checked = true;
                    }
                }


                //展现医疗废物
                if (reader["code"].ToString() == "Z02")
                {
                    PRODU_CNT7.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT7.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE7.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT7.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT7.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE7.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE7.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER7.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT7.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT7.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT7.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT7.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT7.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT7.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID7.Checked = true;
                    }
                }

                //展现危险废物其它
                if (reader["code"].ToString() == "Z89")
                {
                    PRODU_CNT8.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT8.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE8.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT8.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT8.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE8.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE8.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER8.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT8.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT8.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT8.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT8.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT8.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT8.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID8.Checked = true;
                    }
                }

                //展现冶炼废物
                if (reader["code"].ToString() == "Z81")
                {
                    PRODU_CNT9.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT9.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE9.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT9.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT9.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE9.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE9.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER9.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT9.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT9.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT9.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT9.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT9.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT9.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID9.Checked = true;
                    }
                }

                //展现煤粉灰
                if (reader["code"].ToString() == "Z71")
                {
                    PRODU_CNT10.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT10.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE10.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT10.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT10.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE10.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE10.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER10.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT10.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT10.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT10.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT10.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT10.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT10.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID10.Checked = true;
                    }
                }

                //展现炉渣
                if (reader["code"].ToString() == "Z72")
                {
                    PRODU_CNT11.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT11.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE11.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT11.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT11.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE11.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE11.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER11.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT11.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT11.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT11.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT11.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT11.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT11.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID11.Checked = true;
                    }
                }

                //展现煤矸石
                if (reader["code"].ToString() == "Z75")
                {
                    PRODU_CNT12.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT12.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE12.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT12.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT12.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE12.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE12.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER12.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT12.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT12.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT12.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT12.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT12.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT12.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID12.Checked = true;
                    }
                }

                //展现尾矿
                if (reader["code"].ToString() == "Z76")
                {
                    PRODU_CNT13.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT13.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE13.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT13.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT13.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE13.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE13.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER13.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT13.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT13.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT13.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT13.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT13.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT13.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID13.Checked = true;
                    }
                }

                //展现放射性废物
                if (reader["code"].ToString() == "F01")
                {
                    PRODU_CNT14.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT14.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE14.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT14.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT14.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE14.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE14.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER14.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT14.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT14.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT14.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT14.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT14.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT14.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID14.Checked = true;
                    }
                }

                //展现其他废物
                if (reader["code"].ToString() == "Z99")
                {
                    PRODU_CNT15.Text = reader["PRODU_CNT"].ToString();
                    HARM_PERCENT15.Text = reader["HARM_PERCENT"].ToString();
                    SOLID_SUMREUSE15.Text = reader["SOLID_SUMREUSE"].ToString();
                    SOLID_LASTYSAVECNT15.Text = reader["SOLID_LASTYSAVECNT"].ToString();
                    DEAL_COUNT15.Text = reader["DEAL_COUNT"].ToString();
                    SOLID_REACHDISPOSE15.Text = reader["SOLID_REACHDISPOSE"].ToString();
                    SOLID_OVERDISPOSE15.Text = reader["SOLID_OVERDISPOSE"].ToString();
                    GO_CENTER15.Text = reader["GO_CENTER"].ToString();
                    SOLID_DISPOSECOUNT15.Text = reader["SOLID_DISPOSECOUNT"].ToString();
                    SOLID_COUNT15.Text = reader["SOLID_COUNT"].ToString();
                    REACH_SAVECNT15.Text = reader["REACH_SAVECNT"].ToString();
                    OVER_SAVECNT15.Text = reader["OVER_SAVECNT"].ToString();
                    SOLID_SUMCOUNT15.Text = reader["SOLID_SUMCOUNT"].ToString();
                    YEAR_SUMCOUNT15.Text = reader["YEAR_SUMCOUNT"].ToString();
                    if (reader["IF_MOVE_ID"].ToString() == "1")
                    {
                        IF_MOVE_ID15.Checked = true;
                    }
                }
            }
            if (yy == 0)
            {
                string sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z90','1','" + Session["ShenBaoNianDu"] + "')";

                //Response.Write(sqlstr);

                reader.Close();
                sqlcon.Open();
                SqlCommand sqlcmd1 = new SqlCommand(sqlstr, sqlcon);

                sqlcmd1.ExecuteNonQuery();


                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z21','1','" + Session["ShenBaoNianDu"] + "')";

                sqlcmd1.CommandText = sqlstr;

                sqlcmd1.ExecuteNonQuery();

                //增加含铜废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z22','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();
                //增加含铅废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z31','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加废有机溶剂
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z42','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加废矿物质
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z08','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加医疗废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z02','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();


                //增加危险废物其它
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z89','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加冶炼废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z81','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加煤粉灰
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z71','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加炉渣
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z72','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加煤矸石
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z75','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加尾矿
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z76','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加放射性废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','F01','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

                //增加其他废物
                sqlstr = @"insert into  a01109 ([qiyeid],[ShenBaoNianDu],[code],[fact_id],[data_month] ) 
                values (" + Session["qiyeid"] + ",'" + Session["ShenBaoNianDu"] + "','Z99','1','"
                + Session["ShenBaoNianDu"] + "')";

                sqlcmd.CommandText = sqlstr;

                sqlcmd.ExecuteNonQuery();

            }
        }
        sqlcon.Close();

    }

    public string DisplayStr()
    {
        string biaoid = "101109";
        SqlConnection sqlcon = new SqlConnection();
        sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString;
        sqlcon.Open();

        SqlCommand sqlcmd1 = new SqlCommand("select * from tishi where substring(tishiid,1,6)='" + biaoid + "'", sqlcon);
        //reader.Close();
        //sqlcon.Open();
        SqlDataReader reader1 = sqlcmd1.ExecuteReader(CommandBehavior.CloseConnection);
        string joinstr = "[";
        while (reader1.Read())
        {
            joinstr = joinstr + "{'tishiid':'" + reader1["tishiid"].ToString() + "','idmingcheng':'" + reader1["idmingcheng"].ToString() + "','ti1':'" + reader1["ti1"].ToString() + "','ti2':'" + reader1["ti2"].ToString() + "','ti3':'" + reader1["ti3"].ToString() + "'},";
        }

        joinstr = joinstr.Substring(0, joinstr.Length - 1);
        joinstr = joinstr + "]";

        //TextBox99.Text = joinstr;
        reader1.Close();
        sqlcon.Close();

        return joinstr;
    }

    protected void SOLID_LASTYSAVECNT1_TextChanged(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection sqlcon = new SqlConnection();
        sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString;
        sqlcon.Open();

        SqlCommand sqlcmd = new SqlCommand("select * from  a01109 where ShenBaoNianDu='" + Session["ShenBaoNianDu"] + "' and qiyeid=" + Session["qiyeid"], sqlcon);

        SqlDataReader reader = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);

        if (reader.Read())
        {
            string if_move_id = "";
            if (IF_MOVE_ID1.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            string sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT1.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT1.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE1.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT1.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT1.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE1.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE1.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER1.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT1.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT1.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT1.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT1.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT1.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT1.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z90'";

            reader.Close();
            sqlcon.Open();
            SqlCommand sqlcmd1 = new SqlCommand(sqlstr, sqlcon);

            sqlcmd1.ExecuteNonQuery();

            //含铬废物
            //含铬废物
            if (IF_MOVE_ID2.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT2.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT2.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE2.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT2.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT2.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE2.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE2.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER2.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT2.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT2.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT2.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT2.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT2.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT2.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z21'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();
            //含铜废物
            if (IF_MOVE_ID3.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT3.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT3.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE3.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT3.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT3.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE3.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE3.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER3.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT3.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT3.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT3.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT3.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT3.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT3.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z22'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //含铅废物
            if (IF_MOVE_ID4.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT4.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT4.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE4.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT4.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT4.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE4.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE4.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER4.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT4.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT4.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT4.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT4.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT4.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT4.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z31'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //废有机溶剂
            if (IF_MOVE_ID5.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT5.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT5.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE5.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT5.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT5.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE5.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE5.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER5.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT5.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT5.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT5.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT5.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT5.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT5.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z42'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //废矿物质
            if (IF_MOVE_ID6.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT6.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT6.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE6.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT6.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT6.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE6.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE6.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER6.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT6.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT6.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT6.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT6.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT6.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT6.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z08'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //医疗废物
            if (IF_MOVE_ID7.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT7.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT7.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE7.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT7.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT7.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE7.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE7.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER7.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT7.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT7.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT7.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT7.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT7.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT7.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z02'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //危险废物其它
            if (IF_MOVE_ID8.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT8.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT8.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE8.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT8.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT8.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE8.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE8.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER8.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT8.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT8.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT8.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT8.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT8.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT8.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z89'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //冶炼废物
            if (IF_MOVE_ID9.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT9.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT9.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE9.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT9.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT9.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE9.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE9.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER9.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT9.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT9.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT9.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT9.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT9.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT9.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z81'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //煤粉灰
            if (IF_MOVE_ID10.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT10.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT10.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE10.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT10.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT10.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE10.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE10.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER10.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT10.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT10.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT10.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT10.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT10.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT10.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z71'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //炉渣
            if (IF_MOVE_ID11.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT11.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT11.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE11.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT11.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT11.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE11.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE11.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER11.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT11.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT11.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT11.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT11.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT11.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT11.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z72'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //煤矸石
            if (IF_MOVE_ID12.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT12.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT12.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE12.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT12.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT12.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE12.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE12.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER12.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT12.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT12.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT12.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT12.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT12.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT12.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z75'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //尾矿
            if (IF_MOVE_ID13.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT13.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT13.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE13.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT13.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT13.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE13.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE13.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER13.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT13.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT13.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT13.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT13.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT13.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT13.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z76'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //放射性废物
            if (IF_MOVE_ID14.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT14.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT14.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE14.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT14.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT14.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE14.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE14.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER14.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT14.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT14.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT14.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT14.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT14.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT14.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='F01'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //其他废物
            if (IF_MOVE_ID15.Checked)
            {
                if_move_id = "1";

            }
            else
            {
                if_move_id = "0";
            }

            sqlstr = @"update a01109 set 
            PRODU_CNT='" + PRODU_CNT15.Text.Trim() + "',"
            + "HARM_PERCENT='" + HARM_PERCENT15.Text.Trim() + "',"
            + "SOLID_SUMREUSE='" + SOLID_SUMREUSE15.Text.Trim() + "',"
            + "SOLID_LASTYSAVECNT='" + SOLID_LASTYSAVECNT15.Text.Trim() + "',"
            + "DEAL_COUNT='" + DEAL_COUNT15.Text.Trim() + "',"
            + "SOLID_REACHDISPOSE='" + SOLID_REACHDISPOSE15.Text.Trim() + "',"
            + "SOLID_OVERDISPOSE='" + SOLID_OVERDISPOSE15.Text.Trim() + "',"
            + "GO_CENTER='" + GO_CENTER15.Text.Trim() + "',"
            + "SOLID_DISPOSECOUNT='" + SOLID_DISPOSECOUNT15.Text.Trim() + "',"
            + "SOLID_COUNT='" + SOLID_COUNT15.Text.Trim() + "',"
            + "REACH_SAVECNT='" + REACH_SAVECNT15.Text.Trim() + "',"
            + "OVER_SAVECNT='" + OVER_SAVECNT15.Text.Trim() + "',"
            + "SOLID_SUMCOUNT='" + SOLID_SUMCOUNT15.Text.Trim() + "',"
            + "YEAR_SUMCOUNT='" + YEAR_SUMCOUNT15.Text.Trim() + "',"
            + "IF_MOVE_ID='" + if_move_id + "',"
            + "jy='weijiaoyan'" + " where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"] + " and code='Z99'";

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            //根据数据更新合计列的值
            sqlstr = @"update a01109 set DEAL_COUNT=SOLID_REACHDISPOSE+SOLID_OVERDISPOSE where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"];
            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            sqlstr = @"update a01109 set SOLID_COUNT=REACH_SAVECNT+OVER_SAVECNT where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"];
            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();


            sqlstr = @"update a01109 set PRODU_CNT=(SOLID_SUMREUSE-SOLID_LASTYSAVECNT)+(DEAL_COUNT-SOLID_DISPOSECOUNT)+
            SOLID_COUNT+YEAR_SUMCOUNT where ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"];

            sqlcmd.CommandText = sqlstr;

            sqlcmd.ExecuteNonQuery();

            sqlstr = @"select * from a01109 where SOLID_COUNT>SOLID_SUMCOUNT and ShenBaoNianDu='" + Session["ShenBaoNianDu"]
            + "' and qiyeid=" + Session["qiyeid"];

            sqlcmd.CommandText = sqlstr;
            SqlDataReader reader1 = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);

            string jy = "";
            int yzcw = 0;
            if (reader1.Read())
            {
                jy = "14.历年累计贮存量要大于等于11.贮存量合计。\n";
                yzcw = 1;
            }
            if (yzcw == 0)//BIOLER_CNT
            {

                sqlstr="update  a01109 set jy='ruanjian' where ShenBaoNianDu='" + Session["ShenBaoNianDu"] + "' and qiyeid=" + Session["qiyeid"];
                sqlcmd.CommandText = sqlstr;
                reader1.Close();
                sqlcon.Open();
                sqlcmd.ExecuteNonQuery();
                sqlcon.Close();
                Label88.Text = "更新完成";
            }
            else
            {
                Label88.Text = "更新有错误";
                TextBox99.Text = jy;
            }


        }

        reader.Close();
        sqlcon.Close();


    }
}